Open Excel

Command Prototype

objExcelWorkBook = Excel.OpenExcel(sPath,bVisible)

Command Description

Open an Excel workbook file by specifying the path (creates the file if it does not exist) and return an Excel object, supporting xls, xlsx and xlsm formats

Parameter Description

Required Parameter

sPath--The path to Excel file, if the file doesn't exist in the specified path, the command will create it in this path

bVisible--Whether to open Excel in visualization mode

return

objExcelWorkBook--The variable used to save the output of the function call